#mysql -hlocalhost -uroot -p123456 d_stock -e "delete * from t_task_hold"
#mysql -hlocalhost -uroot -p123456 d_stock -e "delete * from t_task_detail"

#mysql -hlocalhost -uroot -p123456 d_stock -e "update t_daily_task set c_task_status=0 where c_task_id in (1,2,3)"

TODAY=`date +%F`

#mysql -hlocalhost -uroot -p123456 d_stock -e "insert into t_daily_task (c_date,c_task_status,c_task_msg,c_condition,createTime) values ('$TODAY',0,'REDAY','t_stock_price_A|30000|100|6|10-5:-0.0001,0.0001:1,2.0-100.0:10.0;5-4:-0.0001,0.0001:1,2.0-100.0:10.0;4-3:-0.0001,0.0001:1,2.0-100.0:10.0;3-2:-0.0001,0.0001:1,2.0-100.0:10.0;2-1:0.05,0.15:1,2.0-100.0:10.0;1-0:0.08,0.12:1,2.0-100.0:10.0;|0|100|0.00|0.00|0-2:0.01,0.50;0-10:0.10,0.50;0-20:0.40,0.60;x0-1:-0.05,0.30;x0-2:-0.10,0.50;x0-3:-0.15,0.80;|1|2013-05-16|2013-05-30|',now())"

mysql -hlocalhost -uroot -p123456 d_stock -e "insert into t_daily_task (c_date,c_task_status,c_task_msg,c_condition,createTime) values ('$TODAY',0,'REDAY','t_stock_price_A|30000|100|5|9-4:-0.0001,0.0001:1,2.0-100.0:10.0;4-3:-0.0001,0.0001:1,2.0-100.0:10.0;3-2:-0.0001,0.0001:1,2.0-100.0:10.0;2-1:-0.0001,0.0001:1,2.0-100.0:10.0;1-0:0.05,0.15:1,2.0-100.0:10.0;|0|100|0.00|0.00|0-2:0.01,0.50;0-10:0.10,0.50;0-20:0.40,0.60;x0-1:-0.05,0.30;x0-2:-0.10,0.50;x0-3:-0.15,0.80;|1|2013-05-16|2013-05-30|',now())"

mysql -hlocalhost -uroot -p123456 d_stock -e "insert into t_daily_task (c_date,c_task_status,c_task_msg,c_condition,createTime) values ('$TODAY',0,'REDAY','t_stock_price_A|30000|100|5|9-4:-0.0001,0.0001:1,2.0-100.0:10.0;4-3:-0.0001,0.0001:1,2.0-100.0:10.0;3-2:-0.0001,0.0001:1,2.0-100.0:10.0;2-1:-0.0001,0.0001:1,2.0-100.0:10.0;1-0:0.05,0.15:1,2.0-100.0:10.0;|0|100|0.00|0.00|0-2:0.01,0.50;0-10:0.10,0.50;0-20:0.40,0.60;x0-1:-0.05,0.30;x0-2:-0.10,0.50;x0-3:-0.15,0.80;|1|2013-05-17|2013-05-30|',now())"
